All about Mary Cole

Extract values from a String

Hi,

I have a String which is in the following format.

IS there a way in Java to extract the value after NAME: , VERSION: and CAT: using REGEX?

Thanks in advance

12 years ago

Java in General

Connect to MS SQl Server

Any help on this?

13 years ago

JDBC and Relational Databases

Connect to MS SQl Server

Hi,
I am trying to connect to SQL server Express DB installed on localbox from my java program. I am using jtds driver and the sample code is below.

When I try to run the program, I get an error saying "java.sql.SQLException: Network error IOException: Connection refused: connect"

If I use

I get an error "java.sql.SQLException: Server localhost has no instance named SQLEXPRESS."

I have the driver jar in class path and my VM args are "-Djava.library.path=C:\jtds-1.2.5-dist\x64\SSO" pointing to the NTLM dll.
I am able to connect to the DB from the MS SQL Server Management Studio.

Can somebody help me to solve this?

13 years ago

JDBC and Relational Databases

Disadvantages of spring annotations

Hi,

can somebody outline the disadvantages of spring annotations compared to declaring it in the XML file

Thanks

13 years ago

Spring

Spring and Hibernate problem

This is how .classpath in my STS proj looks

13 years ago

Spring

Spring and Hibernate problem

Hi,

Am trying out a simple example using Spring3.1 and Hibernate 4.x and am getting this exception

java.lang.ClassCastException: org.springframework.orm.hibernate4.SessionHolder cannot be cast to org.springframework.orm.hibernate3.SessionHolder
at org.springframework.orm.hibernate3.SessionFactoryUtils.doGetSession(SessionFactoryUtils.java:287)
at org.springframework.orm.hibernate3.SessionFactoryUtils.getSession(SessionFactoryUtils.java:233)
at org.springframework.orm.hibernate3.HibernateTemplate.getSession(HibernateTemplate.java:457)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:393)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:737)
at com.demo.dao.UserDAOImpl.saveUser(UserDAOImpl.java:26)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy19.saveUser(Unknown Source)
at com.demo.junit.UserTest.testCreateData(UserTest.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:74)
at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:83)
at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:231)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:71)
at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:174)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

My config files and java code is shown below

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.1.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd
">
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="packagesToScan" value="com.demo" />
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${jdbc.hibernate.dialect}</prop>
<prop key="hibernate.hbm2ddl.auto">create</prop>

<prop key="hibernate.hbm2ddl.auto">create</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
</bean>
<bean id="transactionManager"
class="org.springframework.orm.hibernate4.HibernateTransactionManager">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<tx:annotation-driven />
</beans>

package com.demo.dao;
import java.util.List;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;
import com.demo.User;
@Repository("userDAO")
public class UserDAOImpl implements UserDAO {
private HibernateTemplate hibernateTemplate;
@Autowired
public void setSessionFactory(SessionFactory sessionFactory) {
hibernateTemplate = new HibernateTemplate(sessionFactory);
}
@Transactional(readOnly = false)
@Override
public void saveUser(User user) {
hibernateTemplate.saveOrUpdate(user);
}
@SuppressWarnings("unchecked")
@Override
public List<User> getAllUser(User user) {
return (List<User>) hibernateTemplate.find("from "
+ User.class.getName());
}
@Override
public User selectUserById(String userId) {
return hibernateTemplate.get(User.class, userId);
}
@Transactional(readOnly = false)
@Override
public void deleteUser(User user) {
hibernateTemplate.delete(user);
}
}

package com.demo.junit;
import java.util.List;
import org.apache.log4j.BasicConfigurator;
import org.apache.log4j.Logger;
import org.junit.Assert;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import com.demo.User;
import com.demo.dao.UserDAO;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration( { "/appConfig.xml" })
public class UserTest {
private UserDAO userDAO;
public UserDAO getUserDAO() {
return userDAO;
}
@Autowired
public void setUserDAO(UserDAO userDAO) {
this.userDAO = userDAO;
}
private static final Logger LOGGER = Logger.getLogger(UserTest.class);
@Before
public void init() throws Exception
{
// Log4J junit configuration.
BasicConfigurator.configure();
}
@Test
public void testCreateData() {
int expectedResult = 1;
User user = new User();
user.setAge(23);
user.setUserName("Jackie");
user.setRegistered(true);
userDAO.saveUser(user);
Assert.assertEquals(expectedResult, userDAO.getAllUser(new User()).size());
}
@Test
public void testRetrieveData() {
List<User> userList = userDAO.getAllUser(new User());
Assert.assertEquals(1, userList.size());
User userExpected = userList.get(0);
User userResult = userDAO.selectUserById(userExpected.getUserId());
Assert.assertEquals(userExpected.getUserId(), userResult.getUserId());
}
@Test
public void testUpdateData() {
List<User> userList = userDAO.getAllUser(new User());
Assert.assertEquals(1, userList.size());
User userExpected = userList.get(0);
userExpected.setUserName("Jackie John");
userDAO.saveUser(userExpected);
User userResult = userDAO.selectUserById(userExpected.getUserId());
Assert.assertEquals(userExpected.getUserName(), userResult
.getUserName());
}
@Test
public void testDeleteData() {
/*List<User> userList = userDAO.getAllUser(new User());
Assert.assertEquals(1, userList.size());
User userExpected = userList.get(0);
userDAO.deleteUser(userExpected);
User userResult = userDAO.selectUserById(userExpected.getUserId());
Assert.assertEquals(userResult, null); */
}
}

Can anybody help me where am wrong?

Thanks

13 years ago

Spring

Epoch to groovy date

Hi,

How do I convert epoch time to groovy date?

13 years ago

Groovy

Race condition

Hi,

I have a multithreaded spring stand alone app running on 2 boxes. I have a service method which checks for a record in DB and if its not there, it tries to insert in the DB. I want to handle a situation where if one thread on box A is querying to find a record, another thread on Box B should not have queried and tried to inserted the record if it didn't existed. I have constraints in DB which would throw an exception, but is there a way in Spring to prevent this race condition

Thanks in advance

13 years ago

Spring

Forward JSF to other pages

Hi,
I have an application which uses both struts and JSF. On the JSF list page, I have a button and on click of the button , I need to forward the request to a struts form. I tried it with

and nothing happens. If I try redirect, the page gets forwarded but all the request scope attributes are lost. ANy ideas will be appreciated

Thanks

13 years ago

JSF

Classcast Exception

Hi,

I am trying to write a custom tree component by extending the primefaces Tree component.I have implemented all the methods and my facesConfig and facelet.taglib.xml looks like this

When I access the page, I get the error

Are my entries correct in the faces and taglib.xml?

Appreciate your input

13 years ago

JSF

Custom Regex Validator

Hi,

I need to write a custom validator which can accept the regex expression as an attribute. Can anybody please point me to the right resource or ideas?

13 years ago

JSF

Regex question

Hi,
I want to validate a company name field and it can accept only alpha numeric values at the beginning and at the end and can have space or comma or a single quote anywhere else. So I need a regex expression to validate it.Any help is appreciated
Thanks in advance

13 years ago

Java in General

Regex Help

Rahul, thanks for your reply. The \s doesn't seem to work. Also it should allow single quote anywhere in hte string except at the start and end of the string.

The regex gives error if I enter "Aabc,12312-4555"

FYI, am using Java to validate this

13 years ago

Programmer Certification (OCPJP)

Regex Help

Hi,
I want to validate a String so that it can start and end with alphanumeric characters, but can contain only space, comma or dash anywhere else. Can I get the regex for this validation please?

Thanks in advance

13 years ago

Programmer Certification (OCPJP)

JSF validation

Thanks TIm, it worked

13 years ago

JSF

Mary Cole

Recent posts by Mary Cole