Sorry for my ignorance. Doesn't it mean the java:/DefaultDS point to
PostgreSQL 7.2 ? Can I keep Hypersonic SQL as default in JBoss server and
choose pgsql in the client application?Thanks.
<datasource>java:/DefaultDS</datasource>
<!-- datasource-mapping>Hypersonic SQL</datasource-mapping -->
<datasource-mapping>PostgreSQL 7.2</datasource-mapping>
Derek
-----Original Message-----
From: Dan Christopherson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 2:02 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] error in using pgsql 7.2
The only thing I see is that your datasource tag is still pointing to
java:/DefaultDS. Did you set up the postgres-service.xml to deploy at
that location? Did you also remove the hypersonic configuration that was
at that location?
-danch
[EMAIL PROTECTED] wrote:
> My version of JBoss is 3.0.2 running in Mandrake 8.2 . My steps are
> described below.Could somebody help me identify the error?Thanks very
much.
>
> 1. copy postgres-service.xml to $JBOSS_HOME/server/default/deploy
> 2. add a login module configuration as below to login-config.xml
>
> <application-policy name = "PostgresDbRealm">
> <authentication>
> <login-module code =
> "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag =
> "required">
> <module-option name = "principal">postgres</module-option>
> <module-option name = "userName">postgres</module-option>
> <module-option name = "password"></module-option>
> <module-option name =
>
"managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=PostgresDS</
module-option>
> </login-module>
> </authentication>
> </application-policy>
>
> 3. copy my sample jar file to $JBOSS_HOME/server/default/deploy with
> jbosscmp-jdbc.xml modified as
> <defaults>
> <datasource>java:/DefaultDS</datasource>
> <!-- datasource-mapping>Hypersonic SQL</datasource-mapping -->
> <datasource-mapping>PostgreSQL 7.2</datasource-mapping>
> <create-table>true</create-table>
> <remove-table>true</remove-table>
> </defaults>
>
> 4. get the following error.(It works fine if I use the Hypersonic
> SQL).I've also tried the create table statement in my postgreSQL and it
> works ok.
>
> 09:27:04,585 INFO [MainDeployer] Starting deployment of package:
> file:/usr/local/java/jboss-3.0.2/server/default/deploy/titan.jar
> 09:27:04,648 INFO [EjbModule] Creating
> 09:27:04,667 INFO [EjbModule] Deploying CustomerEJB
> 09:27:04,694 INFO [EjbModule] Created
> 09:27:04,695 INFO [EjbModule] Starting
> 09:27:04,876 WARN [ServiceController] Problem starting service
> jboss.j2ee:service=EJB,jndiName=CustomerHomeRemote
> org.jboss.deployment.DeploymentException: Error while creating table; -
> nested throwable: (java.sql.SQLException: Wrong data type: INT4 in
> statement [CREATE TABLE CUSTOMER (ID INT4 NOT NULL, LAST_NAME TEXT,
> FIRST_NAME TEXT, HAS_GOOD_CREDIT BOOLEAN NOT NULL, CONSTRAINT
> PK_CUSTOMER PRIMARY KEY (ID))])
> at
>
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand
.java:175)
> at
>
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.jav
a:84)
> at
>
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreM
anager.java:457)
> at
>
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:
369)
> at
>
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java
:198)
> at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
> at org.jboss.ejb.Container.invoke(Container.java:764)
> at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
> at
>
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.jav
a:967)
> at $Proxy5.start(Unknown Source)
> at
> org.jboss.system.ServiceController.start(ServiceController.java:396)
>
> at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
> at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at
>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispat
cher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
>
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy71.start(Unknown Source)
> at org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
> at
> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)
> 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:324)
> at
>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispat
cher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
>
> at
>
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.jav
a:967)
> at $Proxy5.start(Unknown Source)
> at
> org.jboss.system.ServiceController.start(ServiceController.java:396)
>
> at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
> at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at
>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispat
cher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
>
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy9.start(Unknown Source)
> at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:394)
> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:802)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:616)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:580)
> at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
> at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at
>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispat
cher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
>
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy4.deploy(Unknown Source)
> at
>
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanne
r.java:427)
> at
>
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.
java:553)
> at
>
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(
AbstractDeploymentScanner.java:212)
> at
>
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(Ab
stractDeploymentScanner.java:225)
> at
>
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(Abs
tractDeploymentScanner.java:202)
> Caused by: java.sql.SQLException: Wrong data type: INT4 in statement
> [CREATE TABLE CUSTOMER (ID INT4 NOT NULL, LAST_NAME TEXT, FIRST_NAME
> TEXT, HAS_GOOD_CREDIT BOOLEAN NOT NULL, CONSTRAINT PK_CUSTOMER PRIMARY
> KEY (ID))]
> at org.hsqldb.Trace.getError(Trace.java:180)
> at org.hsqldb.Result.<init>(Result.java:175)
> at org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:907)
> at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718)
> at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)
> at org.hsqldb.jdbcStatement.executeUpdate(jdbcStatement.java:85)
> at
>
org.jboss.resource.adapter.jdbc.local.LocalStatement.executeUpdate(LocalStat
ement.java:231)
> at
>
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand
.java:166)
> ... 52 more
> 09:27:04,888 INFO [EjbModule] Started
> 09:27:04,888 INFO [MainDeployer] Deployed package:
> file:/usr/local/java/jboss-3.0.2/server/default/deploy/titan.jar
> 09:27:04,891 ERROR [URLDeploymentScanner] MBeanException: Exception in
> MBean operation 'checkIncompleteDeployments()'
> Cause: Incomplete Deployment listing:
> Packages waiting for a deployer:
> <none>
> Incompletely deployed packages:
> <none>
> MBeans waiting for classes:
> <none>
> MBeans waiting for other MBeans:
> [ObjectName: jboss.j2ee:service=EJB,jndiName=CustomerHomeRemote
> state: FAILED
> I Depend On:
> Depends On Me: org.jboss.deployment.DeploymentException: Error
> while creating table; - nested throwable: (java.sql.SQLException: Wrong
> data type: INT4 in statement [CREATE TABLE CUSTOMER (ID INT4 NOT NULL,
> LAST_NAME TEXT, FIRST_NAME TEXT,
> HAS_GOOD_CREDIT BOOLEAN NOT NULL, CONSTRAINT PK_CUSTOMER PRIMARY
> KEY (ID))])]
-------------------------------------------------------
This SF.NET email is sponsored by: Geek Gift Procrastinating?
Get the perfect geek gift now! Before the Holidays pass you by.
T H I N K G E E K . C O M http://www.thinkgeek.com/sf/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
