Bill
I'm not sure if anyone got back to you on this... I was just trawling
through my mail backlog and saw it.
You are right: there was a change in JAWS defined finder code recently
to get away from substituting text in the SQL given to a
PreparedStatement, and to use PreparedStatement parameters instead.
It is now only coincidental that the format being used in the XML is the
same as that used by MessageFormat.
regards
Justin
In message <[EMAIL PROTECTED]>, Bill
Pfeiffer <[EMAIL PROTECTED]> writes
>Did the method to specify replacement args in a finder method change in this
>release?
>
>In the previous binary release I could specify the placement of my finder
>args using the following format:
>
>cust_id = {0,number,######} AND parent_id = {1,number,#########}
>
>After looking at the code for the current release, it appears that JAWS is
>only looking for the argument number and no longer looking for the number
>format information. Is this the case? Are there any docs on this?
>
>My current jaws.xml appears to be failing at parseInt which makes sense if
>JAWS is only looking for the argument index and NOT the formatting info. My
>console output follows.
>
>Any info as to what the NullPointerExceptions (SQL NPE) on the JawCMPFields
>might mean would be also be appreciated.
>
>TIA for any help,
>
>Bill Pfeiffer
>Arbitration Forums, Inc
>[EMAIL PROTECTED]
>[EMAIL PROTECTED]
>
>
>--------------------------------
>
>[Console logging] Logging started
>[Classpath] Added directory:file:/C:/Java/jBoss2.0_pr3/log/
>[Info] Java version: 1.3.0,Sun Microsystems Inc.
>[Info] Java VM: Java HotSpot(TM) Client VM 1.3.0-C,Sun Microsystems Inc.
>[Info] System: Windows 2000 5.0,x86
>[Classpath] Added directory:file:/C:/Java/jBoss2.0_pr3/db/
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/activation.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/awt.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/dynaserver.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/ejb.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/ejxeditor.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/ejxejb.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/ejxjaws.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/ejxjboss.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/hsql.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/idb.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/jboss.jar
>[Classpath] Added
>library:file:/C:/Java/jBoss2.0_pr3/lib/ext/jdbc2_0-stdext.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/jmxtools.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/jndi.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/jnpserver.jar
>[Classpath] Added
>library:file:/C:/Java/jBoss2.0_pr3/lib/ext/jpl-util-0_5b.jar
>[Classpath] Added
>library:file:/C:/Java/jBoss2.0_pr3/lib/ext/jta-spec1_0_1.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/mail.jar
>[Classpath] Added library:file:/C:/Java/jBoss2.0_pr3/lib/ext/xml.jar
>[JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
>[JDBC] Loaded JDBC-driver:jdbc.idbDriver
>[JDBC] Loaded JDBC-driver:sun.jdbc.odbc.JdbcOdbcDriver
>[Webserver] Initializing
>[Webserver] Initialized
>[Hypersonic] Initializing
>[Hypersonic] Server.run/init: java.net.BindException: Address in use:
>JVM_Bind
>[Hypersonic] Database started
>[Hypersonic] Initialized
>[Naming] Initializing
>[Naming] Naming started on port 1099
>[Naming] Initialized
>[Transaction manager] Initializing
>[Transaction manager] Initialized
>[DataSource] Initializing
>[DataSource] Connection pool for jdbc:idb:../conf/instantdb.properties bound
>to
>InstantDB
>InstantDB - Version 3.12
>[DataSource] Copyright (c) 1997-1999 Instant Computer Solutions Ltd.
>[DataSource] Initialized
>[DataSource] Initializing
>[DataSource] Connection pool for jdbc:HypersonicSQL:hsql://localhost bound
>to Hy
>personic
>[DataSource] Initialized
>[DataSource] Initializing
>[DataSource] Connection pool for jdbc:odbc:ora-beq-local bound to Oracle
>[DataSource] Initialized
>[DataSource] Initializing
>[DataSource] Connection pool for jdbc:odbc:Oasiswin MSS bound to SQLServer
>[DataSource] Initialized
>[Container factory] Initializing
>[Container factory] Initialized
>[Auto deploy] Watching C:\Java\jBoss2.0_pr3\deploy
>[Auto deployer] Initializing
>[Auto deployer] Initialized
>[JMX RMI Adaptor] Initializing
>[JMX RMI Adaptor] Initialized
>[Configuration] Initializing
>[Configuration] Initialized
>[Configuration] MaxActiveClientCount set to 10 in Adaptor:name=html
>[Configuration] Port set to 8082 in Adaptor:name=html
>[Configuration] LibraryDirectory set to C:\Java\jBoss2.0_pr3\bin in
>DefaultDomai
>n:service=MLet
>[Configuration] Format set to [{2}] {4} in
>DefaultDomain:service=Logging,type=Co
>nsole
>[Configuration] Port set to 8083 in DefaultDomain:service=Webserver
>[Configuration] VerifyDeployments set to false in
>EJB:service=ContainerFactory
>[Hypersonic] Starting
>[Hypersonic] Started
>[DataSource] Starting
>[DataSource] Started
>[DataSource] Starting
>[DataSource] Started
>[Transaction manager] Starting
>[Transaction manager] Started
>[DataSource] Starting
>[DataSource] Started
>[DataSource] Starting
>[DataSource] Started
>[Naming] Starting
>[Naming] Started
>[Auto deployer] Starting
>[Auto deploy] Auto deploy of file:/C:/Java/jBoss2.0_pr3/deploy/oasisejb.jar
>[Container factory] Deploying:file:/C:/Java/jBoss2.0_pr3/deploy/oasisejb.jar
>[Container factory] Deploying HierEB
>[JAWS] Initializing JAWS plugin for HierEB
>[Container factory] Caught SQL NPE on JawsCMPField!
>[Container factory] Caught JDBC NPE on JawsCMPField!
>[Container factory] Caught SQL NPE on JawsCMPField!
>[Container factory] Caught JDBC NPE on JawsCMPField!
>[Container factory] Caught SQL NPE on JawsCMPField!
>[Container factory] Caught JDBC NPE on JawsCMPField!
>[Container factory] Caught SQL NPE on JawsCMPField!
>[Container factory] Caught JDBC NPE on JawsCMPField!
>[Container factory] Caught SQL NPE on JawsCMPField!
>[Container factory] Caught JDBC NPE on JawsCMPField!
>[Container factory] Caught SQL NPE on JawsCMPField!
>[Container factory] Caught JDBC NPE on JawsCMPField!
>[Container factory] Caught SQL NPE on JawsCMPField!
>[Container factory] Caught JDBC NPE on JawsCMPField!
> at java.lang.Integer.parseInt(Unknown Source)
> at java.lang.Integer.<init>(Unknown Source)
> at
>org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.makeSql(JAWSPersist
>enceManager.java:1154)
> at
>org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenc
>eManager.java:227)
> at
>org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManage
>r.java:82)
> at org.jboss.ejb.EntityContainer.init(EntityContainer.java:190)
> at org.jboss.ejb.Application.init(Application.java:158)
>[JAWS] Remove:DELETE FROM treeview WHERE cust_id=? AND node_id=?
>[JAWS] Drop:DROP TABLE treeview
>[JAWS] Create table:CREATE TABLE treeview (parent_id INTEGER,cust_id
>INTEGER,nod
>e_id INTEGER,node_type VARCHAR(1),label_text VARCHAR(50),sibling_order
>INTEGER,d
>escription VARCHAR(80))
>[JAWS] Insert:INSERT INTO treeview
>(parent_id,cust_id,node_id,node_type,label_te
>xt,sibling_order,description) VALUES (?,?,?,?,?,?,?)
>[JAWS] Select:SELECT
>parent_id,cust_id,node_id,node_type,label_text,sibling_orde
>r,description FROM treeview WHERE cust_id=? AND node_id=?
>[JAWS] Exists:SELECT COUNT(*) AS Total FROM treeview WHERE cust_id=? AND
>node_id
>=?
>[Container factory] java.lang.NumberFormatException: 0,number,######
> at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:493)
> at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:183)
> at java.lang.reflect.Method.invoke(Native Method)
> at javax.management.MBeanServer.invoke(MBeanServer.java:1635)
> at javax.management.MBeanServer.invoke(MBeanServer.java:1501)
> at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:258)
> at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:194)
> at org.jboss.ejb.AutoDeployer.startService(AutoDeployer.java:237)
> at
>org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:89)
>
> at java.lang.reflect.Method.invoke(Native Method)
> at javax.management.MBeanServer.invoke(MBeanServer.java:1635)
> at javax.management.MBeanServer.invoke(MBeanServer.java:1501)
> at org.jboss.Main.<init>(Main.java:155)
> at org.jboss.Main.<init>(Main.java:86)
> at org.jboss.Main$1.run(Main.java:76)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.jboss.Main.main(Main.java:67)
>[Auto deploy] Deployment
>failed:file:/C:/Java/jBoss2.0_pr3/deploy/oasisejb.jar
>[Auto deploy] org.jboss.ejb.DeploymentException: Could not deploy
>file:/C:/Java/
>jBoss2.0_pr3/deploy/oasisejb.jar
>[Auto deploy] at
>org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:5
>14)
>[Auto deploy] at
>org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:1
>83)
>[Auto deploy] at java.lang.reflect.Method.invoke(Native Method)
>[Auto deploy] at
>javax.management.MBeanServer.invoke(MBeanServer.java:1635)
>[Auto deploy] at
>javax.management.MBeanServer.invoke(MBeanServer.java:1501)
>[Auto deploy] at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:258)
>[Auto deploy] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:194)
>[Auto deploy] at
>org.jboss.ejb.AutoDeployer.startService(AutoDeployer.java:237
>)
>[Auto deploy] at
>org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.
>java:89)
>[Auto deploy] at java.lang.reflect.Method.invoke(Native Method)
>[Auto deploy] at
>javax.management.MBeanServer.invoke(MBeanServer.java:1635)
>[Auto deploy] at
>javax.management.MBeanServer.invoke(MBeanServer.java:1501)
>[Auto deploy] at org.jboss.Main.<init>(Main.java:155)
>[Auto deploy] at org.jboss.Main.<init>(Main.java:86)
>[Auto deploy] at org.jboss.Main$1.run(Main.java:76)
>[Auto deploy] at java.security.AccessController.doPrivileged(Native
>Method)
>[Auto deploy] at org.jboss.Main.main(Main.java:67)
>[Auto deployer] Started
>[Webserver] Starting
>[Webserver] Codebase set to http://localhost:8083/
>[Webserver] Started webserver on port 8083
>[Webserver] Started
>[JMX RMI Adaptor] Starting
>[JMX RMI Adaptor] Started
>[Container factory] Starting
>[Container factory] Started
>[Default] Shutdown hook added
>[Default] jBoss 2.0 Started
>
>
>
>--
>--------------------------------------------------------------
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Problems?: [EMAIL PROTECTED]
>
--
Justin Forder
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
