[JBoss-dev] [ jboss-Bugs-621270 ] invalid SQL is generated for MSSQL
Bugs item #621270, was opened at 2002-10-10 15:07 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=621270group_id=22866 Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 8 Submitted By: Alexei Yudichev (sflexus) Assigned to: Nobody/Anonymous (nobody) Summary: invalid SQL is generated for MSSQL Initial Comment: I have the following EJBQL expression: SELECT DISTINCT OBJECT(c) FROM StoreCategory c, IN (c.locales) l WHERE l.code=?1 AND c.images IS NOT EMPTY which for postgresql translates into: Executing SQL: SELECT DISTINCT t0_c.id FROM storecategory t0_c, mmslocale t1_l, storecategory_locales_m_18q3els t2_c_locales_RELATION_TABLE, mmsimage t3_c_images, mmsimage_storecategorie_1diogue t4_c_images_RELATION_TABLE WHERE (t1_l.code = ? AND TRUE) AND (t0_c.id=t4_c_images_RELATION_TABLE.StoreCategory AND t3_c_images.id=t4_c_images_RELATION_TABLE.MMSImage AND t0_c.id=t2_c_locales_RELATION_TABLE.StoreCategory AND t1_l.code=t2_c_locales_RELATION_TABLE.MMSLocale) and executes normally. But for MSSQL I get: SELECT DISTINCT t0_c.id FROM StoreCategory t0_c, MMSLocale t1_l, StoreCategory_locales_MMSLocale_storeCategories t2_c_locales_RELATION_TABLE, MMSImage t3_c_images, MMSImage_storeCategories_StoreCategory_images t4_c_images_RELATION_TABLE WHERE (t1_l.code = ? AND 1) AND (t0_c.id=t4_c_images_RELATION_TABLE.StoreCategory AND t3_c_images.id=t4_c_images_RELATION_TABLE.MMSImage AND t0_c.id=t2_c_locales_RELATION_TABLE.StoreCategory AND t1_l.code=t2_c_locales_RELATION_TABLE.MMSLocale) which leads to java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ')'. Why not using AND 1=1 instead of AND 1? -- Comment By: Alexey Loubyansky (loubyansky) Date: 2002-10-12 17:42 Message: Logged In: YES user_id=543482 Have you really tested it with MS SQLSERVER and has it failed? I don't have MS SQLSERVER to test. But I've tested it against MySQL that have true-mapping the same as MS SQLSERVER does. And it works fine: select * from document where sent=(1=1) Field 'sent' is boolean and represented in the db as '1'. -- Comment By: Alexei Yudichev (sflexus) Date: 2002-10-12 00:50 Message: Logged In: YES user_id=345880 Isn't the same boolean mapping used for dealing with boolean types in queries like SELECT ID FROM FOO WHERE SOME_BOOLEAN_FIELD=?1 ? If so, substituting (1=1) will crash such queries: SELECT ID FROM FOO WHERE SOME_BOOLEAN_FIELD=(1=1) That's why I posted this as a bug. -- Comment By: Alexey Loubyansky (loubyansky) Date: 2002-10-11 11:20 Message: Logged In: YES user_id=543482 If I got you right, it's the problem with true-mapping. Currently, for MS SQLSERVER: true-mapping1/true-mapping false-mapping0/false-mapping I am not familiar with MS SQLSERVER but if you are sure it should be true-mapping(1=1)/true-mapping false-mapping(1=0)/false-mapping like for Hypersonic, I'll fix it. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=621270group_id=22866 --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] Requesting Posts
__ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] Eclipse and JBoss Howto posted.
A thread concerning how to use Eclipse to develop Jboss was started a while back.. I finally got the time to put together a little howto to explain how to use eclipse to develop JBoss. You will find it in the Developer Guides section of the Jboss website the next time the website gets rebuilt. Regards, Hiram --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] Automated JBoss(Branch_3_0) Testsuite Results: 12-October-2002
Number of tests run: 949
Successful tests: 948
Errors:1
Failures: 0
[time of test: 12 October 2002 12:44 GMT]
[java.version: 1.3.1]
[java.vendor: Apple Computer, Inc.]
[java.vm.version: 1.3.1_03-69]
[java.vm.name: Java HotSpot(TM) Client VM]
[java.vm.info: mixed mode]
[os.name: Mac OS X]
[os.arch: ppc]
[os.version: 10.2.1]
See http://lubega.com/testarchive/${build.uid} for details of this test.
See http://lubega.com for general test information.
NOTE: If there are any errors shown above - this mail is only highlighting
them - it is NOT indicating that they are being looked at by anyone.
Remember - if a test becomes broken after your changes - fix it or fix the test!
Oh dear - still got some errors!
Thanks for all your effort - we really do love you!
---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] [ jboss-Bugs-618410 ] NPE during deploying WAR
Bugs item #618410, was opened at 2002-10-04 03:48
You can respond by visiting:
https://sourceforge.net/tracker/?func=detailatid=376685aid=618410group_id=22866
Category: JBossWeb
Group: v3.2
Status: Open
Resolution: None
Priority: 5
Submitted By: Vladimir Korenev (vkorenev)
Assigned to: Nobody/Anonymous (nobody)
Summary: NPE during deploying WAR
Initial Comment:
OS: Win2000
JDK: 1.4.1-rc
JBoss v. 3.0.3 with Jetty
An error occures when JBoss starts:
10:03:37,396 ERROR [URLDeploymentScanner]
Failed to deploy: org.jboss.deployment
.scanner.URLDeploymentScanner$DeployedURL@64
67598e{ url=file:/D:/java/jboss-3.0.
3/server/default/deploy/cboss.ear/,
deployedLastModified=0 }
org.jboss.deployment.DeploymentException: -
nested throwable: (java.lang.NullPoi
nterException)
at org.jboss.jetty.Jetty.deploy(Jetty.java:434)
at org.jboss.jetty.JettyService.performDeploy
(JettyService.java:243)
at org.jboss.web.AbstractWebContainer.start
(AbstractWebContainer.java:30
0)
at org.jboss.deployment.MainDeployer.start
(MainDeployer.java:802)
at org.jboss.deployment.MainDeployer.start
(MainDeployer.java:794)
at org.jboss.deployment.MainDeployer.deploy
(MainDeployer.java:616)
at org.jboss.deployment.MainDeployer.deploy
(MainDeployer.java:580)
at
sun.reflect.GeneratedMethodAccessor9.invoke
(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke
(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.i
nvoke(ReflectedMBea
nDispatcher.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.URLDeploymentScann
er.deploy(URLDeploymen
tScanner.java:427)
at
org.jboss.deployment.scanner.URLDeploymentScann
er.scanDirectory(URLDe
ploymentScanner.java:648)
at
org.jboss.deployment.scanner.URLDeploymentScann
er.scan(URLDeploymentS
canner.java:499)
at
org.jboss.deployment.scanner.AbstractDeploymentS
canner.startService(A
bstractDeploymentScanner.java:261)
at org.jboss.system.ServiceMBeanSupport.start
(ServiceMBeanSupport.java:1
64)
at
sun.reflect.GeneratedMethodAccessor7.invoke
(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke
(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.i
nvoke(ReflectedMBea
nDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke
(MBeanServerImpl.java:517)
at
org.jboss.system.ServiceController$ServiceProxy.inv
oke(ServiceControl
ler.java:976)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start
(ServiceController.java:397)
at
sun.reflect.GeneratedMethodAccessor6.invoke
(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke
(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.i
nvoke(ReflectedMBea
nDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke
(MBeanServerImpl.java:517)
at org.jboss.util.jmx.MBeanProxy.invoke
(MBeanProxy.java:174)
at $Proxy3.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start
(SARDeployer.java:249)
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 org.jboss.deployment.MainDeployer.deploy
(MainDeployer.java:564)
at
sun.reflect.NativeMethodAccessorImpl.invoke0
(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke
(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.i
nvoke(ReflectedMBea
nDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke
(MBeanServerImpl.java:517)
at org.jboss.system.server.ServerImpl.doStart
(ServerImpl.java:324)
at org.jboss.system.server.ServerImpl.start
(ServerImpl.java:221)
at org.jboss.Main.boot(Main.java:148)
at org.jboss.Main$1.run(Main.java:381)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.lang.NullPointerException
at org.mortbay.j2ee.session.Manager.start
(Manager.java:159)
at org.mortbay.jetty.servlet.ServletHandler.start
(ServletHandler.java:40
9)
at
org.mortbay.jetty.servlet.WebApplicationHandler.sta
rt(WebApplicationH
andler.java:142)
